starstarstarstarstar_half
Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course. Let’s discuss now what you will learn from this course. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course. Then you will work with 3-D Referencing with Excel Formulas. In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions , Text manipulating functions, and many more. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions. Then you have worked with VLOOKUP, INDEX, and Array formulas. And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions. So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course!
    star_border star_border star_border star_border star_border
    This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel. You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries. By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.
      starstarstarstarstar_half
      Supercharge your Microsoft Excel Spreadsheets Microsoft Excel contains hundreds of built in functions, such as SUM, AVERAGE, MIN, IF, VLOOKUP and many more. In this Microsoft Excel Advanced Functions course, you will learn two of the most powerful functions Excel has to offer. Tasks that would normally require complex, specific setups and a lot of back and forth, can be completed with ease using these functions you'll master during this course. Not all Excel Functions are Created Equal As you participate in this course I'll guide through a series of exercises tailored to give you the greatest exposure and step by step instruction as you learn to harness the power of Excel's INDEX() and MATCH() functions. We'll start out with the fundamental building blocks of creating complex calculations by building a solid foundation, mastering: Relative vs. Absolute References Using Name Ranges to Create Dynamic Data References Function Shortcuts Breaking Down the Calculation by using Microsoft Excels Formula Auditing Tools After you master these building block concepts we will then dive into several real world scenarios, where I'll take you step by step through the finer points of creating dynamic and robust formulas using Excel's INDEX() and MATCH() functions. Understand and Implement the INDEX and MATCH functions Create Dynamic LOOKUPS by Combining Functions Creating ARRAY Functions with INDEX and IF Functions Add Multiple Criteria to the INDEX and MATCH Functions Combine INDEX/MATCH and MIN to Return Associated Data Points Build Complex Conditional Formatting with Calculations Learn by Participating I've found one of the best ways to learn and master something new, is to apply the knowledge as soon as possible. In order to help you learn and master the skills taught in this course, I'm supplying downloadable exercise files for you to use in order to follow along with. The course also includes a Q&A section where you can ask questions, reply to other students and myself. Supercharge Your Excel Skills Now What are you waiting for? Enroll now and join me and take your next steps to mastering Microsoft Excel.
        star_border star_border star_border star_border star_border
        This course is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. It is centered on teaching students how to master the art and science of problem solving with formulas in Excel. The course takes a unique approach that is rooted in solving real world problems . This gives students an apprenticeship experience as opposed to a traditional lecture approach. By the end of the course, students will have worked nearly 170 examples and will have learned how to leverage Excel to solve just about any problem they might face in practice. Students will cover just under 100 functions in the course and will be proficient in reading and writing even the most complex formulas in Excel. The course is broken down into two modules. The first module provides an introduction to Excel. This module is intended to get everyone on the same page, so even those who have never used Excel can feel comfortable starting with this course . The second module teaches students how to become formula masters and expert problem solvers with Excel. This module is broken down into seven sections that are mapped to functional areas, once again putting an emphasis on how Excel is used in the real world. This course offers students: Over 16 hours of valuable video instruction that is uniquely structured to share the lessons learned from over a decade of professional experience Over 125 quiz questions strategically placed throughout the course to help test your understanding and reinforce what you’ve learned A Practical Application Workbook and solution manual for each section An Excel Wizard’s Guide to Critical Skills A Comprehensive Data Aggregation Reference Sheet This course is intended for individuals who have a desire to become phenomenal at writing formulas in Excel. This includes: Recent or soon to be college graduates Individuals who work in analyst, consulting, management, or supervisory roles Individuals looking to gain a tangible skill on their resume Individuals looking to gain a competitive advantage over their peers Recent studies show it pays to know Excel. Get started today!
          starstarstarstarstar_border
          This course is all about excel functions, if you are looking for automating your job and make it easier this is the right course for you, so excel functions are so important for 2 main reasons, the first one is time saving and the second one is eliminating human errors. In this course you will learn over 40 most important excel functions, for each function i will explain it in details and show you its syntax then will show you how to do it in excel sheets step by step.
            starstarstarstarstar_half
            Data analysis in Excel for Microsoft 365 has become simpler than ever. We have NEW Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE! PLUS: Microsoft has changed Excel’s calculation engine. This change impacts EVERYONE who uses Microsoft 365 version: Beginner to Advanced Excel users. There are MULTIPLE ways you can apply Dynamic Arrays and the NEW Excel Functions to YOUR Files. This course shows you how to MAXIMIZE the NEW Potential in Excel 365! For example: Use Excel's new FILTER Function to find multiple match results Use Excel's new XLOOKUP function for complex lookups (no more VLOOKUP or Index Match) Create Excel Dashboard reports in MINUTES instead of HOURS Create Pivot Table style reports, without using Pivot Tables - no need to press "refresh" this way Quickly create dynamic loan amortization reports in Excel or dynamic calendars Master the new UNIQUE, SORT & SORTBY Excel Functions Use the brand new Excel RANDARRAY Function to randomly sort lists Use VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulas In addition you'll learn: How to add Interactivity to your Excel reports as never done before How to use the new Dynamic Arrays formulas in your files How Excel's calculation engine has changed and how this impacts all existing formulas Compatibility & how older files behave in the new Excel and New Excel files in the old Excel Do Dynamic Arrays make our spreadsheets faster or slower? Use Dynamic Array referencing as Excel chart ranges Solve difficult problems - such as split text and numbers from alphanumeric values & much more... Most importantly - how to think outside the box to solve any challenges you come across But First: *** HOW TO CHECK IF YOUR EXCEL VERSION HAS DYNAMIC ARRAYS *** Do you have Excel for Microsoft 365? Then you already have dynamic arrays and the new Excel functions. Check out the free preview video called "Do you have Dynamic Arrays?" and do the test outline in the video. If you don't have dynamic arrays BUT you have Excel for Microsoft 365 run the latest update to install the new features. But please note: Excel dynamic arrays will NOT be a part of Excel 2010, Excel 2013, Excel 2016 or EVEN Excel 2019. Only in Excel 365 or Excel on the web. *** WHY TAKE THIS SPECIFIC EXCEL COURSE? *** Excel Dynamic Arrays are brand-new. Complex tasks will now be done with SIMPLE Excel formulas . Everything you wished Excel could do, can now be done! In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder. In the course you will get: ⯆ Excel Practice & Solutions Workbooks for each section ⯆ Course notes outlining the MOST IMPORTANT Concepts ⯆ Quiz questions to test your understanding ***  WHY WOULD YOU CHOOSE TO LEARN EXCEL?  *** Excel can do so much for your career. It's just one program but it's the one hiring managers are interested in. That’s why basic Excel skills is a mandatory requirement for most office-based professionals today. Superior Microsoft Excel skills can get you a promotion. Some jobs require that to begin with. *** WHICH VERSION OF EXCEL IS USED IN THE COURSE? *** The course is applicable ONLY for Excel for Microsoft 365 (Also available for Excel on the Web). Dynamic Arrays will NOT be part of Excel 2019 perpetual license. *** Feedback from our students *** ★★★★★ "I highly recommend this well-organized course for anyone whose work/projects involve data analysis. The knowledge I've gained on the new dynamic array functions will raise the level of my analysis while making my work easier at the same time. The new functions are well explained with business examples, and the course notes will be a great reference!" Jennifer ★★★★★ “This course is magical. I am sure everyone using Excel will have to upgrade their knowledge soon. Thanks for the enlightening journey.” Dheeraj ★★★★★ “Very well organized and implemented course. It was easy to follow along yet challenging enough to learn. As an example, I had never used the CHOOSE function which was your solution in one of the advanced challenges. Still wanting to try and figure out the solution on my own (without seeing yours first), I tried watching a video from another YouTube instructor on that specific function. Unfortunately, I didn't really get it until I watched your instruction. The way you break down the components of a complex formula, showing various examples of how they work, before building up to the complete solution is a great method of teaching. Your advice for spilling component results next to the source data is an excellent method for troubleshooting formula problems...if I could only get the hang of it and remember to do it!” Stephanie ★★★★★ “I give you a big 10 for the explanation of this course, I learned a lot from it.” Jos There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work. The course comes with lifetime access. Buy now. Watch anytime.
              starstarstarstarstar_half
              If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you! The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - This is How: Use my top 10 tips to save time Learn the top 10 formulas for quick and dynamic analysis This course includes a detailed downloadable PDF of the top 10 Tips & Formulas - together over 90 pages! Now you can READ, WATCH or do BOTH! The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method. In Their Own Words: Carlo says: "Excellent course featuring loads of easily understood content. It helped me become very competent and comfortable with pivot tables along with a host of other functionality. It's easily understood and also easy to follow. Instructor speaks clearly and explains things well, very helpful so the information is easily retained. " Sahar says: "Very very helpful tips. Anyone who uses Excel should learns these to let them get more benefits of the embedded functionalities. " Steven says: "Well explained, excellent material and topics. Definitely very helpful for my everyday work. " Advanced Excel skills are highly relevant in business . No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in Finance, consulting, IT, in project management, your advanced Excel skills will set you apart from the competition. What is the difference between an Advanced Excel and Average Excel user? An advanced Microsoft Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation.  Advanced Excel users, always find the optimal solution for every task, and they find it fast! What differentiates this Microsoft Excel course from the others? The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel. Differentiation factor #1 Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel. Differentiation factor #2 Learn by doing - This Advanced Microsoft Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Excel Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered. Differentiation factor #3 Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later. Summary My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method. Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Take this course to get a head start!
                starstarstarstarstar_half
                Learn to calculate how much money you can save by making additional payments into your home loan / mortgage or other loan. In this course we'll learn how to use the Financial Loan formulas in Excel to calculate how much money you can save when making additional payments into your loan.  We'll also learn to calculate the exact period at which you can pay your loan off.  This will really assist you to set achievable goals regarding your outstanding mortgage bond. This course will take you through a step-by-step guide to create a spreadsheet which details the payment for each period of a loan over the lifetime of the loan.  In the example we look at a mortgage bond of 1,500,000 which is paid monthly over 20 years. The course is created using Excel 2016 and although prior versions of Excel have all the same functionality, the screen may look different so if you are not comfortable using Excel you could get confused.  You really should have some basic knowledge of Excel already and you should be able to use formulas and understand how to link cells into formulas. The topics we cover in the course are: The Excel PMT function to calculate the monthly payment The Excel IPMT function to calculate the interest portion of each months payment The Excel PPMT function to calculate the principal (capital) portion of each months payment The Excel IF function for logical conditions It is very encouraging to calculate how much you can save on your bond with even small additional amounts! You can easily find templates or similar calculations but this course will truly help you understand how a loan works.
                  starstarstarstarstar_half
                  In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Recent reviews: "This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course." "Excellent, efficient and informative course. The exercises after each set of videos was particularly useful." "I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement." In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. **** Life time access to course materials and practice activities. **** Welcome to this course on Tables, Conditional Formatting and Excel formulas.  This course is for all Excel users who want to take their Excel skills and capabilities to the next level. This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets.  The course is presented in an easy to follow step by step approach.  The course also includes practical activities for you to practice the skills that you have been learnt on the course. The course will provide you with a comprehensive understanding of the following: Tables How to create and format Tables How to easily filter data in text, numeric and date fields Easily Sum, Average, Count and use Max and Min in your tables Use Slicers to easily filter Table data Conditional Formatting How to apply conditional formatting rules How to easily highlight the Top 10 Learn to use Data Bars and Color Scales Learn to apply icons Formulas Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay Learn Text formulas such as LEFT, MID, RIGHT and TRIM Learn to use the IF formula to create powerful 'IF Then' logic Learn the HLOOKUP and VLOOKUP This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.
                    star_border star_border star_border star_border star_border
                    WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself. A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics. This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory. ONLINE TRAINING AND THE MOST COMMON PROBLEMS One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time. Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy. COURSE DELIVERY STYLE I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing. WHAT YOU’LL LEARN IN THIS COURSE The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored! I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation. Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion. ABOUT ME Member of the Udemy Council Co-Founded Paperclip Learning which teaches Microsoft Office Over 60,000 students Over 130,000 enrollments Over 5,000 Positive Reviews Over 20 courses on Udemy Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics. TESTIMONIALS Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!! Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing. Spencer Berkman - Extremely knowledgeable and clear on instructions. E Frank - Simple to learn techniques and instructor made it all really easy. Thank you! Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach